﻿CREATE TABLE [dbo].[UDS_Class] (
    [ClassID]        int           NOT NULL identity(1, 1),
    [ClassName]      nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL,
    [ClassRemark]    nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL,
    [ClassType]      int           NULL,
    [ClassParentID]  int           NULL,
    [ClassAddedBy]   nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
    [ClassAddedDate] datetime      NULL,
    [Status]         int           NULL CONSTRAINT [DF_UDS_Class_Status] default(((0))),
    
    CONSTRAINT [PK_UDS_Class] PRIMARY KEY (ClassID asc)
);
GO

SET NOCOUNT ON;
SET IDENTITY_INSERT dbo.UDS_Class ON;

DECLARE @date datetime;
SET @date = getdate();

INSERT INTO dbo.UDS_Class (ClassID, ClassName, ClassRemark, ClassType, ClassParentID, ClassAddedBy, ClassAddedDate, Status) VALUES(1, N'公司项目', N'公司项目', 0, 1, N'admin', @date, 0);
INSERT INTO dbo.UDS_Class (ClassID, ClassName, ClassRemark, ClassType, ClassParentID, ClassAddedBy, ClassAddedDate, Status) VALUES(77, N'人员管理', N'人员管理', 4, 77, N'admin', @date, 0);
INSERT INTO dbo.UDS_Class (ClassID, ClassName, ClassRemark, ClassType, ClassParentID, ClassAddedBy, ClassAddedDate, Status) VALUES(81, N'我的项目', N'我的项目', 5, 81, N'admin', @date, 0);
INSERT INTO dbo.UDS_Class (ClassID, ClassName, ClassRemark, ClassType, ClassParentID, ClassAddedBy, ClassAddedDate, Status) VALUES(82, N'我的邮件', N'私人邮件列表', 7, 82, N'admin', @date, 0);
INSERT INTO dbo.UDS_Class (ClassID, ClassName, ClassRemark, ClassType, ClassParentID, ClassAddedBy, ClassAddedDate, Status) VALUES(106, N'我的文档', N'我的文档', 8, 106, N'admin', @date, 0);
INSERT INTO dbo.UDS_Class (ClassID, ClassName, ClassRemark, ClassType, ClassParentID, ClassAddedBy, ClassAddedDate, Status) VALUES(119, N'公文流转', N'公文流转', 9, 119, N'admin', @date, 0);
INSERT INTO dbo.UDS_Class (ClassID, ClassName, ClassRemark, ClassType, ClassParentID, ClassAddedBy, ClassAddedDate, Status) VALUES(191, N'职位管理', N'职位管理', 12, 191, N'admin', @date, 0);
INSERT INTO dbo.UDS_Class (ClassID, ClassName, ClassRemark, ClassType, ClassParentID, ClassAddedBy, ClassAddedDate, Status) VALUES(192, N'角色管理', N'角色管理', 13, 192, N'admin', @date, 0);
INSERT INTO dbo.UDS_Class (ClassID, ClassName, ClassRemark, ClassType, ClassParentID, ClassAddedBy, ClassAddedDate, Status) VALUES(193, N'考勤查询', N'考勤查询', 14, 193, N'admin', @date, 0);
INSERT INTO dbo.UDS_Class (ClassID, ClassName, ClassRemark, ClassType, ClassParentID, ClassAddedBy, ClassAddedDate, Status) VALUES(194, N'考勤管理', N'考勤管理', 15, 194, N'admin', @date, 0);
INSERT INTO dbo.UDS_Class (ClassID, ClassName, ClassRemark, ClassType, ClassParentID, ClassAddedBy, ClassAddedDate, Status) VALUES(199, N'短讯管理', N'站内消息及手机短讯', 16, 199, N'admin', @date, 0);

SET IDENTITY_INSERT dbo.UDS_Class OFF;